<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/hyy_217/article/details/72771802"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"授权指定ip访问mysql 服务器 - Hua的博客"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>授权指定ip访问mysql 服务器 - Hua的博客 - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-9b39979775.min.css">
        <script type="text/javascript">
        var username = "hyy_217";
        var blog_address = "https://blog.csdn.net/hyy_217";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/hyy_217/article/details/72771802"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin3-template";
        // 收藏所需数据
        var articleTitle = "授权指定ip访问mysql 服务器";
        var articleDesc = "授权指定ip访问访问授权ROOT使用密码1234从应用服务器主机连接到mysql服务器mysql>GRANTALLPRIVILEGESON*.*TO root@xxx.xxx.xxx.xxx IDENTIFIEDBY1234WITHGRANTOPTION;mysql>flushprivileges; mysql授权任";
        // 第四范式所需数据
        var articleTitles = "授权指定ip访问mysql 服务器 - Hua的博客";
        
        var nickName = "hyy_217";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/hyy_217/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/hyy_217/article/details/72771802";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">授权指定ip访问mysql 服务器</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年05月26日 17:06:14</span>
                    <a class="follow-nickName" href="https://me.csdn.net/hyy_217" target="_blank">hyy_217</a>
                    <span class="read-count">阅读数 4235</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/hyy_217/article/details/72771802"> https://blog.csdn.net/hyy_217/article/details/72771802</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                <div class="htmledit_views" id="content_views">
                                            
<p align="left"><span style="font-size:24px;">授权指定ip访问访问<br /></span></p>
<p align="left"><span style="font-size:24px;"><span style="color:#FF0000;">授权</span><span style="color:#FF0000;">ROOT</span><span style="color:#FF0000;">使用</span><span style="color:#FF0000;">密码1234</span><span style="color:#FF0000;">从应用服务器主机连接到</span><span style="color:#FF0000;">mysql</span><span style="color:#FF0000;">服务器</span></span></p>
<p><span style="font-size:24px;"><span style="color:#333333;background:#E6E6E6;">mysql&gt; GRANT ALL PRIVILEGES ON *.* TO </span><span style="background:#E6E6E6;">'<span style="color:#FF0000;">root</span>'@'<span style="color:#FF0000;">xxx.xxx.xxx.xxx</span>'<span style="color:#333333;"> </span></span><span style="color:#333333;">IDENTIFIED
 BY '</span><span style="color:#FF0000;">1234</span><span style="color:#333333;">' WITH GRANT OPTION;</span></span></p>
<p><span style="font-size:24px;"><span style="color:#333333;background:#E6E6E6;">mysql&gt; flush privileges;</span><span style="background:#E6E6E6;"> </span></span></p>
<p><span style="background:#E6E6E6;"><span style="font-size:24px;"><br /></span></span></p>
<p><span style="background:#E6E6E6;"><span style="font-size:24px;"><br /></span></span></p>
<p><span style="background:#E6E6E6;"></span></p>
<p align="left"><span style="font-size:24px;">mysql授权任意地址访问</span></p>
<p align="left"><span style="font-size:24px;color:#ff0000;">授权ROOT使用1234从任何主机连接到mysql服务器</span></p>
<p><span style="font-size:24px;"><span style="color:#333333;background:#E6E6E6;">mysql&gt; GRANT ALL PRIVILEGES ON *.* TO </span><span style="background:#E6E6E6;">'<span style="color:#FF0000;">root</span>'@'%'<span style="color:#333333;"> </span></span><span style="color:#333333;">IDENTIFIEDBY
 '</span><span style="color:#FF0000;">1234</span><span style="color:#333333;">'WITH GRANT OPTION;</span></span></p>
<span style="font-size:24px;"><span style="color:rgb(51,51,51);">mysql&gt; flush privileges;</span><span> </span></span><br />                                    </div>
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/hyy_217/article/details/72771802","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/hyy_217/article/details/72771802","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-402","con":",,"}' data-track-click='{"mod":"kp_popu_58-402","con":",,"}' data-report-view='{"mod":"kp_popu_58-402","keyword":""}' data-report-click='{"mod":"kp_popu_58-402","keyword":""}'><div style="width:100%;background:#fff;border:3px solid #fff;padding:16px 0px 0px 0px;">
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<div id="three_ad1" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 100,
                showid : 'ztvJV8',
                placeholderId: "three_ad1",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 0,
                    imageWidth: 90,
                    imageHeight: 68,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft YaHei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 20,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="72771802">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xiuzhentianting/article/details/52154327","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiuzhentianting/article/details/52154327" target="_blank" title="mysql授权ip访问">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>授权</em><em>ip</em><em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1447</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiuzhentianting/article/details/52154327" target="_blank" title="mysql授权ip访问">
				<span class="desc oneline">GRANTALLPRIVILEGESON*.*TO'root'@'192.168.1.11'IDENTIFIEDBY'pwd'WITH   GRANTOPTION; FLUSH PRIVILEGES;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiuzhentianting">来自：	<span class="blog_title"> xiuzhentianting的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42392874/article/details/80584624","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42392874/article/details/80584624" target="_blank" title="设置mysql允许外部IP连接的解决方法及遇到的坑说明">
		<h4 class="text-truncate oneline">
				设置<em>mysql</em>允许外部<em>IP</em>连接的解决方法及遇到的坑说明		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-06</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42392874/article/details/80584624" target="_blank" title="设置mysql允许外部IP连接的解决方法及遇到的坑说明">
				<span class="desc oneline">今天要打包了一个springboot的docker镜像，在启动镜像的时候，报连不上数据库。查看springboot工程里面数据库连接的配置，发现连接的ip是localhost。心想在容器内部访问的lo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42392874">来自：	<span class="blog_title"> IT技术猿生</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/v2810769/article/details/77638686","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/v2810769/article/details/77638686" target="_blank" title="MySql 允许任意ip进行访问，配置方法。">
		<h4 class="text-truncate oneline">
				<em>MySql</em> 允许任意<em>ip</em>进行<em>访问</em>，配置方法。		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-28</span>
				<span class="read-num hover-hide">
					阅读数 
					5095</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/v2810769/article/details/77638686" target="_blank" title="MySql 允许任意ip进行访问，配置方法。">
				<span class="desc oneline">写实用的博客。首先在数据库的根路径下执行：mysql-uroot-pmysql第二步mysql&gt;GRANTALLPRIVILEGESON.TO‘root’@’%’IDENTIFIEDBY‘111’WI...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/v2810769">来自：	<span class="blog_title"> 傅鹏程的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a295277302/article/details/77891658","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a295277302/article/details/77891658" target="_blank" title="通过IP访问MYsql">
		<h4 class="text-truncate oneline">
				通过<em>IP</em><em>访问</em><em>MYsql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-08</span>
				<span class="read-num hover-hide">
					阅读数 
					3500</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a295277302/article/details/77891658" target="_blank" title="通过IP访问MYsql">
				<span class="desc oneline">mysql-uroot-pusemysql;授权法:例如，你想myuser使用mypassword从任何主机连接到mysql服务器的话。GRANTALLPRIVILEGESON*.*TO'myuser...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a295277302">来自：	<span class="blog_title"> a295277302的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/phoenix_main/article/details/82821273","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/phoenix_main/article/details/82821273" target="_blank" title="如何给MySQL数据库添加远程IP连接授权用户">
		<h4 class="text-truncate oneline">
				如何给<em>MySQL</em>数据库添加远程<em>IP</em>连接<em>授权</em>用户		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-23</span>
				<span class="read-num hover-hide">
					阅读数 
					723</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/phoenix_main/article/details/82821273" target="_blank" title="如何给MySQL数据库添加远程IP连接授权用户">
				<span class="desc oneline">1.首先登录MySQL数据库这个不用我多说了吧,不管你是Windows还是Ubuntu的系统,sql命令都是一样的mysql-u用户名-p请输入密码:用户名的话,一般默认的为root输入你的密码,进入...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/phoenix_main">来自：	<span class="blog_title"> phoenix_main的web之路的历程</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_43714335/article/details/84169093","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_43714335/article/details/84169093" target="_blank" title="Mysql创建用户与授权，限制IP">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>创建用户与<em>授权</em>，限制<em>IP</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-17</span>
				<span class="read-num hover-hide">
					阅读数 
					952</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_43714335/article/details/84169093" target="_blank" title="Mysql创建用户与授权，限制IP">
				<span class="desc oneline">1.创建用户CREATEUSER'dog'@'localhost'IDENTIFIEDBY'123456';CREATEUSER‘用户名’@‘限制的IP地址’IDENTIFIEDBY‘密码’;2.授权...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_43714335">来自：	<span class="blog_title"> weixin_43714335的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u012195899/article/details/52473902","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012195899/article/details/52473902" target="_blank" title="MYSQL远程访问，授权IP等常用命令">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>远程<em>访问</em>，<em>授权</em><em>IP</em>等常用命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012195899/article/details/52473902" target="_blank" title="MYSQL远程访问，授权IP等常用命令">
				<span class="desc oneline">grantallprivilegeson*.*to'root'@'192.168.1.1'identifiedby'密码';</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012195899">来自：	<span class="blog_title"> 九天</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hnxuwei/article/details/50481749","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hnxuwei/article/details/50481749" target="_blank" title="MySql实现远程连接，用户grant授权">
		<h4 class="text-truncate oneline">
				<em>MySql</em>实现远程连接，用户grant<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hnxuwei/article/details/50481749" target="_blank" title="MySql实现远程连接，用户grant授权">
				<span class="desc oneline">1、进入mysql，创建一个新用户root,密码为root：格式：grant权限on数据库名.表名to用户@登录主机identifiedby“用户密码”;grantselect,update,inse...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hnxuwei">来自：	<span class="blog_title"> hnxuwei的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/gongzi2311/article/details/50245913","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gongzi2311/article/details/50245913" target="_blank" title="Mysql通过IP连接授权">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>通过<em>IP</em>连接<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-10</span>
				<span class="read-num hover-hide">
					阅读数 
					1380</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gongzi2311/article/details/50245913" target="_blank" title="Mysql通过IP连接授权">
				<span class="desc oneline">可以使用Navicat登录管理员账户，新建一个用户并对用户授权，如下： grantallprivilegeson*.*TO'root'@'%'identifiedby'root'withgrantop...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/gongzi2311">来自：	<span class="blog_title"> 公子的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_40584261/article/details/91396750","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_40584261/article/details/91396750" target="_blank" title="MySQL用户IP授权">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>用户<em>IP</em><em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-10</span>
				<span class="read-num hover-hide">
					阅读数 
					75</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_40584261/article/details/91396750" target="_blank" title="MySQL用户IP授权">
				<span class="desc oneline">1、登录mysql，然后执行下面的语句进行授权。GRANTALLPRIVILEGESON*.*TOroot@&quot;192.168.10.111&quot;IDENTIFIEDBY&quot;yourpassword&quot;WITH...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_40584261">来自：	<span class="blog_title"> weixin_40584261的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yueyeqingshan/article/details/52767665","strategy":"BlogCommendFromBaidu","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yueyeqingshan/article/details/52767665" target="_blank" title="配置mysql指定的ip授权访问">
		<h4 class="text-truncate oneline">
				配置<em>mysql</em><em>指定</em>的<em>ip</em><em>授权</em><em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-09</span>
				<span class="read-num hover-hide">
					阅读数 
					415</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yueyeqingshan/article/details/52767665" target="_blank" title="配置mysql指定的ip授权访问">
				<span class="desc oneline">GRANTALLPRIVILEGESON*.*TO'root'@'192.168.140.199'IDENTIFIEDBY'ht'WITHGRANTOPTION</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yueyeqingshan">来自：	<span class="blog_title"> 青衫-CSDN博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/anzhen0429/article/details/74078387","strategy":"BlogCommendFromBaidu","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/anzhen0429/article/details/74078387" target="_blank" title="MySQL访问权限系统和访问控制">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>访问</em>权限系统和<em>访问</em>控制		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-01</span>
				<span class="read-num hover-hide">
					阅读数 
					4209</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/anzhen0429/article/details/74078387" target="_blank" title="MySQL访问权限系统和访问控制">
				<span class="desc oneline">6.1一般安全问题6.1.1安全指南    运行MySQL时，请遵循以下准则：   (1)不要给任何人（MySQLroot帐户除外）访问数据库中的user表mysql！这是至关重要的。  （2)了解M...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/anzhen0429">来自：	<span class="blog_title"> anzhen0429的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xianyao_shi/article/details/7190877","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xianyao_shi/article/details/7190877" target="_blank" title="设置MYSQL允许用IP访问">
		<h4 class="text-truncate oneline">
				设置<em>MYSQL</em>允许用<em>IP</em><em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-10</span>
				<span class="read-num hover-hide">
					阅读数 
					3万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xianyao_shi/article/details/7190877" target="_blank" title="设置MYSQL允许用IP访问">
				<span class="desc oneline">SQLError(1130):Host'192.168.1.100'isnotallowedtoconnecttothisMySQLserver说明所连接的用户帐号没有远程连接的权限，只能在本机(lo...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xianyao_shi">来自：	<span class="blog_title"> xianyao_shi的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34101229/article/details/92898386","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34101229/article/details/92898386" target="_blank" title="开启 MySQL 的远程登陆帐号有两大步">
		<h4 class="text-truncate oneline">
				开启 <em>MySQL</em> 的远程登陆帐号有两大步		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-09</span>
				<span class="read-num hover-hide">
					阅读数 
					13</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34101229/article/details/92898386" target="_blank" title="开启 MySQL 的远程登陆帐号有两大步">
				<span class="desc oneline">开启MySQL的远程登陆帐号有两大步：1、确定服务器上的防火墙没有阻止3306端口。MySQL默认的端口是3306，需要确定防火墙没有阻止3306端口，否则远程是无法通过3306端口连接到MySQL的...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34101229">来自：	<span class="blog_title"> weixin_34101229的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/xuxile/article/details/53161908","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xuxile/article/details/53161908" target="_blank" title="mysql 创建一个用户，指定一个数据库">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 创建一个用户，<em>指定</em>一个数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-14</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xuxile/article/details/53161908" target="_blank" title="mysql 创建一个用户，指定一个数据库">
				<span class="desc oneline">1.远程登录mysqlmysql-hip-uroot-p密码2.创建用户格式：grant权限on数据库.*to用户名@登录主机identifiedby“密码”;例1：增加一个test1用户，密码为12...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xuxile">来自：	<span class="blog_title"> 许喜乐</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lan_13217/article/details/84689738","strategy":"searchFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lan_13217/article/details/84689738" target="_blank" title="mysql 添加访问ip">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 添加<em>访问</em><em>ip</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-05</span>
				<span class="read-num hover-hide">
					阅读数 
					73</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lan_13217/article/details/84689738" target="_blank" title="mysql 添加访问ip">
				<span class="desc oneline">[code=&amp;quot;java&amp;quot;]首先按下面的步骤登录Mysql服务器登录mysql需要切换到dos下的mysql的bin目录，进行如下操作：mysql&amp;gt;usemysql;mysql...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lan_13217">来自：	<span class="blog_title"> lan_13217的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_25385555/article/details/91047856","strategy":"BlogCommendFromQuerySearch","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_25385555/article/details/91047856" target="_blank" title="mysql   绑定内网ip 允许指定ip访问 新增用户 授权 修改密码">
		<h4 class="text-truncate oneline">
				<em>mysql</em>   绑定内网<em>ip</em> 允许<em>指定</em><em>ip</em><em>访问</em> 新增用户 <em>授权</em> 修改密码		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-06</span>
				<span class="read-num hover-hide">
					阅读数 
					52</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_25385555/article/details/91047856" target="_blank" title="mysql   绑定内网ip 允许指定ip访问 新增用户 授权 修改密码">
				<span class="desc oneline">mysql绑定内网ip允许指定ip访问新增用户授权修改密码为什么这么做?我们的服务器是阿里云服务器，刚开始安装mysql是没有做什么特殊的设置，只开放了默认的3306端口，密码使用最简单的root账号...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_25385555">来自：	<span class="blog_title"> xuyangyang的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/rosejeck/article/details/84343331","strategy":"BlogCommendFromQuerySearch","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/rosejeck/article/details/84343331" target="_blank" title="MySql允许root用户在一个特定的IP进行远程登录，并具有所有库任何操作权限">
		<h4 class="text-truncate oneline">
				<em>MySql</em>允许root用户在一个特定的<em>IP</em>进行远程登录，并具有所有库任何操作权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-07</span>
				<span class="read-num hover-hide">
					阅读数 
					1110</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/rosejeck/article/details/84343331" target="_blank" title="MySql允许root用户在一个特定的IP进行远程登录，并具有所有库任何操作权限">
				<span class="desc oneline">1.首先在本机先使用root用户登录mysql：mysql-uroot-p&amp;amp;amp;amp;amp;amp;quot;youpassword&amp;amp;amp;amp;amp;amp;quot;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/rosejeck">来自：	<span class="blog_title"> rosejeck的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lk7688535/article/details/51474860","strategy":"BlogCommendFromQuerySearch","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lk7688535/article/details/51474860" target="_blank" title="在阿里云centOS的mysql上创建用户并授权所以IP远程访问">
		<h4 class="text-truncate oneline">
				在阿里云centOS的<em>mysql</em>上创建用户并<em>授权</em>所以<em>IP</em>远程<em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-22</span>
				<span class="read-num hover-hide">
					阅读数 
					3958</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lk7688535/article/details/51474860" target="_blank" title="在阿里云centOS的mysql上创建用户并授权所以IP远程访问">
				<span class="desc oneline">第一步：打开SSH工具连接到阿里云服务器第二步进入数据库新建用户并赋予权限mysql-uroot-p&quot;inputyourpassword&quot;//进入数据库usemysql;grantallonstdte...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lk7688535">来自：	<span class="blog_title"> Ezreal</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/u014026084/article/details/79363408","strategy":"BlogCommendFromQuerySearch","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u014026084/article/details/79363408" target="_blank" title="Linux下配置mysql允许指定IP远程访问">
		<h4 class="text-truncate oneline">
				Linux下配置<em>mysql</em>允许<em>指定</em><em>IP</em>远程<em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-24</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u014026084/article/details/79363408" target="_blank" title="Linux下配置mysql允许指定IP远程访问">
				<span class="desc oneline">我们远程的mysql数据库为了安全考虑，在user表里配置了只允许指定IP的地址能够访问，结果今天我的IP变了，就连不上数据库了，这就要重新修改user表里指定的Ip地址。主要步骤如下：1.进入mys...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u014026084">来自：	<span class="blog_title"> u014026084的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lym152898/article/details/79558882","strategy":"BlogCommendFromQuerySearch","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lym152898/article/details/79558882" target="_blank" title="指定远程IP使用root用户访问mysql数据库">
		<h4 class="text-truncate oneline">
				<em>指定</em>远程<em>IP</em>使用root用户<em>访问</em><em>mysql</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-14</span>
				<span class="read-num hover-hide">
					阅读数 
					337</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lym152898/article/details/79558882" target="_blank" title="指定远程IP使用root用户访问mysql数据库">
				<span class="desc oneline">登陆mysql数据库mysql-uroot-p#输入密码更改相关信息#选择user数据库useuser;#刷新权限flushprivileges;#查看user和hostselectuser,host...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lym152898">来自：	<span class="blog_title"> 林贻民的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/ve_love/article/details/19166095","strategy":"BlogCommendFromMachineLearnPai2","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ve_love/article/details/19166095" target="_blank" title="远程连接mysql数据库的授权">
		<h4 class="text-truncate oneline">
				远程连接<em>mysql</em>数据库的<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-13</span>
				<span class="read-num hover-hide">
					阅读数 
					522</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ve_love/article/details/19166095" target="_blank" title="远程连接mysql数据库的授权">
				<span class="desc oneline">1、d:\mysql\bin\&gt;mysql-hlocalhost-uroot 　　//这样应该可以进入MySQL服务器 2、mysql&gt;GRANTALLPRIVILEGESON*.*TO'root'@...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ve_love">来自：	<span class="blog_title"> 小不点程序</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_42001930/article/details/80274615","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_42001930/article/details/80274615" target="_blank" title="mysql5.7.22允许所有外部ip访问数据库。">
		<h4 class="text-truncate oneline">
				<em>mysql</em>5.7.22允许所有外部<em>ip</em><em>访问</em>数据库。		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-10</span>
				<span class="read-num hover-hide">
					阅读数 
					4682</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_42001930/article/details/80274615" target="_blank" title="mysql5.7.22允许所有外部ip访问数据库。">
				<span class="desc oneline">注：以下是阿里云云服务器上mysql允许所有外部ip访问的方法，有个别小伙伴是需要访问同事电脑上本地搭建的数据库，这是需要在局域网内的哦，如果你需要访问同事电脑上本地搭建的数据库，可以加下面的群，小伙...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_42001930">来自：	<span class="blog_title"> weixin_42001930的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/iteye_16909/article/details/82614868","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/iteye_16909/article/details/82614868" target="_blank" title="mysql限制IP登录，授予权限">
		<h4 class="text-truncate oneline">
				<em>mysql</em>限制<em>IP</em>登录，授予权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-28</span>
				<span class="read-num hover-hide">
					阅读数 
					259</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/iteye_16909/article/details/82614868" target="_blank" title="mysql限制IP登录，授予权限">
				<span class="desc oneline">登录mysql服务器，连接MySQL，执行如下两条命令1.GRANTALLPRIVILEGESON *.* TO root@'192.168.204.%'IDENTIFIED BY '123' WIT...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/iteye_16909">来自：	<span class="blog_title"> iteye_16909的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-555","con":",,"}' data-track-click='{"mod":"kp_popu_63-555","con":",,"}' data-report-view='{"mod":"kp_popu_63-555","keyword":""}' data-report-click='{"mod":"kp_popu_63-555","keyword":""}'><div id="three_ad23" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad23",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq122472755/article/details/84123599","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq122472755/article/details/84123599" target="_blank" title="MYSQL授权指定权限指定IP访问指定库">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em><em>授权</em><em>指定</em>权限<em>指定</em><em>IP</em><em>访问</em><em>指定</em>库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-01</span>
				<span class="read-num hover-hide">
					阅读数 
					92</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq122472755/article/details/84123599" target="_blank" title="MYSQL授权指定权限指定IP访问指定库">
				<span class="desc oneline"> 1.授权 --授权app用户从指定IP访问数据库的所有权限grantallprivilegeson*.*to'app'@'10.200.12.232'identifiedby'app1234';--...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq122472755">来自：	<span class="blog_title"> qq122472755的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zdhjiony/article/details/84284709","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zdhjiony/article/details/84284709" target="_blank" title="设置mysql允许外部IP访问">
		<h4 class="text-truncate oneline">
				设置<em>mysql</em>允许外部<em>IP</em><em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-06</span>
				<span class="read-num hover-hide">
					阅读数 
					498</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zdhjiony/article/details/84284709" target="_blank" title="设置mysql允许外部IP访问">
				<span class="desc oneline">默认情况下Mysql只允许本地进入设置，在外网想通过命令行访问mysql，那是没门的，如果需要外部IP连接到mysql，需要向mysql数据库里的“user”表里添加相关授权。例如：让newuser用...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zdhjiony">来自：	<span class="blog_title"> jiony</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box  recommend-other-item-box"  data-report-click='{"mod":"popu_387","dest":"https://bbs.csdn.net/topics/390647977","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<a href="https://bbs.csdn.net/topics/390647977" target="_blank">
		<h4 class="text-truncate oneline">
				<em>mysql</em>如果给同一个网段内的所有<em>ip</em><em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">11-20</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">mysql&gt; grant all privileges on mydb.* to root@'192.168.1.100' identified by '123456'; 怎么给多个ip授权，192.</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/cpk154505/article/details/8768309","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/cpk154505/article/details/8768309" target="_blank" title="mysql新增专给特定IP访问的用户">
		<h4 class="text-truncate oneline">
				<em>mysql</em>新增专给特定<em>IP</em><em>访问</em>的用户		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-07</span>
				<span class="read-num hover-hide">
					阅读数 
					6052</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/cpk154505/article/details/8768309" target="_blank" title="mysql新增专给特定IP访问的用户">
				<span class="desc oneline">1新创建同时授权用户：Sql代码  [root@XX-90 ~]# mysql -root -p  Enter password:   Welcome to the MySQL monitor.  C...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/cpk154505">来自：	<span class="blog_title"> cpk154505的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/kongqz/article/details/6836445","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/kongqz/article/details/6836445" target="_blank" title="设置mysql允许外网访问">
		<h4 class="text-truncate oneline">
				设置<em>mysql</em>允许外网<em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-30</span>
				<span class="read-num hover-hide">
					阅读数 
					4540</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/kongqz/article/details/6836445" target="_blank" title="设置mysql允许外网访问">
				<span class="desc oneline">mysql的root账户,我在连接时通常用的是localhost或127.0.0.1,公司的测试服务器上的mysql也是localhost所以我想访问无法访问,测试暂停.解决方法如下:1,修改表,登录...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/kongqz">来自：	<span class="blog_title"> The Last Song 的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/pf1234321/article/details/85115494","strategy":"BlogCommendFromQuerySearch","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/pf1234321/article/details/85115494" target="_blank" title="mysql MYSQL远程访问 授权IP">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>MYSQL</em>远程<em>访问</em> <em>授权</em><em>IP</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-20</span>
				<span class="read-num hover-hide">
					阅读数 
					231</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/pf1234321/article/details/85115494" target="_blank" title="mysql MYSQL远程访问 授权IP">
				<span class="desc oneline">登陆在本机上使用命令行登陆,并切换到mysql库mysql-uroot-pusemysql;更改权限使用grantallprivilegeson来更改用户对应某些库的远程权限语法模板grantallp...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/pf1234321">来自：	<span class="blog_title"> pf1234321的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/sinat_20769099/article/details/80480153","strategy":"BlogCommendFromQuerySearch","index":"30"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sinat_20769099/article/details/80480153" target="_blank" title="Mysql 5.7 添加指定账号指定ip访问。">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 5.7 添加<em>指定</em>账号<em>指定</em><em>ip</em><em>访问</em>。		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-28</span>
				<span class="read-num hover-hide">
					阅读数 
					1478</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sinat_20769099/article/details/80480153" target="_blank" title="Mysql 5.7 添加指定账号指定ip访问。">
				<span class="desc oneline">1.先创建用户2.授权3. 配置文件中注释掉bind-address=127.0.0.14.如果是云服务器。记得在安全组中开启3306出入口...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sinat_20769099">来自：	<span class="blog_title"> sinat_20769099的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/yzjim/article/details/48750901","strategy":"BlogCommendFromQuerySearch","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/yzjim/article/details/48750901" target="_blank" title="mysql授权用户root使用密码password从指定ip为192.168.1.1的主机连接到mysql服务器">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>授权</em>用户root使用密码password从<em>指定</em><em>ip</em>为192.168.1.1的主机连接到<em>mysql</em><em>服务器</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-26</span>
				<span class="read-num hover-hide">
					阅读数 
					671</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/yzjim/article/details/48750901" target="_blank" title="mysql授权用户root使用密码password从指定ip为192.168.1.1的主机连接到mysql服务器">
				<span class="desc oneline">进入mysql表中usemysql;mysql授权使用密码password从指定ip为192.168.1.1的主机连接到mysql服务器grantallprivilegeson*.*to'root'@...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/yzjim">来自：	<span class="blog_title"> 星城天空的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_36999656/article/details/79840084","strategy":"BlogCommendFromQuerySearch","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_36999656/article/details/79840084" target="_blank" title="mysql设置访问权限 ip段">
		<h4 class="text-truncate oneline">
				<em>mysql</em>设置<em>访问</em>权限 <em>ip</em>段		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-07</span>
				<span class="read-num hover-hide">
					阅读数 
					2467</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_36999656/article/details/79840084" target="_blank" title="mysql设置访问权限 ip段">
				<span class="desc oneline">createuser'user'@'192.168.1.%' identifiedby'******';grantallprivilegeson`database`.*to 'user'@'192.1...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_36999656">来自：	<span class="blog_title"> qq_36999656的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/willfcareer/article/details/5805009","strategy":"BlogCommendFromQuerySearch","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/willfcareer/article/details/5805009" target="_blank" title="Mysql常用操作">
		<h4 class="text-truncate oneline">
				<em>Mysql</em>常用操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-11</span>
				<span class="read-num hover-hide">
					阅读数 
					455</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/willfcareer/article/details/5805009" target="_blank" title="Mysql常用操作">
				<span class="desc oneline">最近碰到大数据量处理问题，涉及到分表策略等，以下是通过sql如何判定表的存在性 Mysql SHOW TABLES LIKE '%tableName%'; SELECTTABLE_NAMEF...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/willfcareer">来自：	<span class="blog_title"> Edwin’s Blog</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/Xu_XiaoXiao_Ji/article/details/85103657","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/Xu_XiaoXiao_Ji/article/details/85103657" target="_blank" title="实现mysql远程（通过IP地址访问）连接">
		<h4 class="text-truncate oneline">
				实现<em>mysql</em>远程（通过<em>IP</em>地址<em>访问</em>）连接		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-19</span>
				<span class="read-num hover-hide">
					阅读数 
					533</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/Xu_XiaoXiao_Ji/article/details/85103657" target="_blank" title="实现mysql远程（通过IP地址访问）连接">
				<span class="desc oneline">(一).MySQL如何实现远程连接，即通过IP地址连接。（1）首先需要设置MySQL数据库中user表中host为%，%代表任意的IP地址。Updatemysql.usersetHost=’%’whe...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/Xu_XiaoXiao_Ji">来自：	<span class="blog_title"> Xu_XiaoXiao_Ji的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/a857553315/article/details/80613678","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/a857553315/article/details/80613678" target="_blank" title="授权远程的IP访问数据库mysql">
		<h4 class="text-truncate oneline">
				<em>授权</em>远程的<em>IP</em><em>访问</em>数据库<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-07</span>
				<span class="read-num hover-hide">
					阅读数 
					137</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/a857553315/article/details/80613678" target="_blank" title="授权远程的IP访问数据库mysql">
				<span class="desc oneline">GRANTALLPRIVILEGESON*.*TO'root'@'远程ip'IDENTIFIEDBY'密码';flushprivileges;</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/a857553315">来自：	<span class="blog_title"> a857553315的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/zhangbest2009/article/details/39893265","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangbest2009/article/details/39893265" target="_blank" title="mysql 根据ip给远程机器授权可以远程访问">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 根据<em>ip</em>给远程机器<em>授权</em>可以远程<em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-08</span>
				<span class="read-num hover-hide">
					阅读数 
					701</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangbest2009/article/details/39893265" target="_blank" title="mysql 根据ip给远程机器授权可以远程访问">
				<span class="desc oneline">grantallprivilegesondatabase_name*touser@159.226.10.102identifiedby'zhang@123';flushprivileges;</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangbest2009">来自：	<span class="blog_title"> 叮咚侠的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/izibeike/article/details/79366607","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/izibeike/article/details/79366607" target="_blank" title="MySQL数据库可以用任意ip连接访问的方法">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>数据库可以用任意<em>ip</em>连接<em>访问</em>的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-25</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/izibeike/article/details/79366607" target="_blank" title="MySQL数据库可以用任意ip连接访问的方法">
				<span class="desc oneline">通过CMD命令行修改数据库表的一个字段的值，实现连接，访问。第一步、找到MYSQL软件安装所在的bin目录；（1）cd\当前目录（2）指定MYSQL安装的bin目录（3）输入-hlocalhost-u...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/izibeike">来自：	<span class="blog_title"> izibeike的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34378045/article/details/87208902","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34378045/article/details/87208902" target="_blank" title="设置root用户通过指定的IP连接Mysql">
		<h4 class="text-truncate oneline">
				设置root用户通过<em>指定</em>的<em>IP</em>连接<em>Mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-12</span>
				<span class="read-num hover-hide">
					阅读数 
					36</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34378045/article/details/87208902" target="_blank" title="设置root用户通过指定的IP连接Mysql">
				<span class="desc oneline">正常线上项目，一个Mysql数据库系统可能会对应提供给多个项目使用，每个项目对应有一个数据库，不同的数据库需要对应分配不同的用户，用户的权限也需要严格区分和控制，增加安全性。同时正常环境下一般不建议使...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34378045">来自：	<span class="blog_title"> weixin_34378045的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_34349320/article/details/92567858","strategy":"BlogCommendFromQuerySearch","index":"39"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34349320/article/details/92567858" target="_blank" title="查看MYSQL数据库中所有用户及拥有权限">
		<h4 class="text-truncate oneline">
				查看<em>MYSQL</em>数据库中所有用户及拥有权限		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-06</span>
				<span class="read-num hover-hide">
					阅读数 
					3</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34349320/article/details/92567858" target="_blank" title="查看MYSQL数据库中所有用户及拥有权限">
				<span class="desc oneline">2019独角兽企业重金招聘Python工程师标准&amp;gt;&amp;gt;&amp;gt;...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34349320">来自：	<span class="blog_title"> weixin_34349320的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/z_h_j_/article/details/63277608","strategy":"BlogCommendFromQuerySearch","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/z_h_j_/article/details/63277608" target="_blank" title="Linux下mysql允许不同网段访问">
		<h4 class="text-truncate oneline">
				Linux下<em>mysql</em>允许不同网段<em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-18</span>
				<span class="read-num hover-hide">
					阅读数 
					1758</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/z_h_j_/article/details/63277608" target="_blank" title="Linux下mysql允许不同网段访问">
				<span class="desc oneline">在linux下搭建mysql数据库时，由于实验室路由器比较多，mysql搭载在主路由的网段下，为了满足二级路由下各网段能访问mysql，于是创建了一个guest用户供各网段统一访问。1.当要求各网段下...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/z_h_j_">来自：	<span class="blog_title"> z_h_j_的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/gianttj/article/details/84878234","strategy":"BlogCommendFromQuerySearch","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gianttj/article/details/84878234" target="_blank" title="mysql 用grant 新建用户指定同一个网段主机的方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 用grant 新建用户<em>指定</em>同一个网段主机的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-02</span>
				<span class="read-num hover-hide">
					阅读数 
					69</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gianttj/article/details/84878234" target="_blank" title="mysql 用grant 新建用户指定同一个网段主机的方法">
				<span class="desc oneline">			mysql用grant新建用户指定同一个网段主机的方法 出于对数据安全的考滤，在生产服务器上mysql的访问权限一般只允许本主机或与之在一个内网的服务器链接，禁止公网服务器的访问。如果用gran...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/gianttj">来自：	<span class="blog_title"> phpsir的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_38627026/article/details/83617786","strategy":"BlogCommendFromQuerySearch","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_38627026/article/details/83617786" target="_blank" title="mysql指定远程ip访问">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>指定</em>远程<em>ip</em><em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-01</span>
				<span class="read-num hover-hide">
					阅读数 
					108</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_38627026/article/details/83617786" target="_blank" title="mysql指定远程ip访问">
				<span class="desc oneline">mysql&amp;amp;gt;GRANTALLPRIVILEGESON.TO‘root’@‘198.56.211.23’IDENTIFIEDBY‘password’WITHGRANTOPTION;mysq...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_38627026">来自：	<span class="blog_title"> qq_38627026的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/lyfly8023/article/details/81197754","strategy":"BlogCommendFromQuerySearch","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lyfly8023/article/details/81197754" target="_blank" title="mysql 用户权限 设置指定用户访问指定数据库">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 用户权限 设置<em>指定</em>用户<em>访问</em><em>指定</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-25</span>
				<span class="read-num hover-hide">
					阅读数 
					1482</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lyfly8023/article/details/81197754" target="_blank" title="mysql 用户权限 设置指定用户访问指定数据库">
				<span class="desc oneline">1、ALTERUSER'user_name'@'host'IDENTIFIEDBY'password';  创建用户：user_name用户名；	host允许访问的主机，（%：允许全部；127.0.0...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lyfly8023">来自：	<span class="blog_title"> lyfly8023的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/liuquan0071/article/details/62423674","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liuquan0071/article/details/62423674" target="_blank" title="mysql设置指定ip访问，用户权限相关操作">
		<h4 class="text-truncate oneline">
				<em>mysql</em>设置<em>指定</em><em>ip</em><em>访问</em>，用户权限相关操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-16</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liuquan0071/article/details/62423674" target="_blank" title="mysql设置指定ip访问，用户权限相关操作">
				<span class="desc oneline">mysqlmysql权限mysql外网ip访问数据库</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33907511/article/details/91104429","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33907511/article/details/91104429" target="_blank" title="MySql授权指定IP可访问">
		<h4 class="text-truncate oneline">
				<em>MySql</em><em>授权</em><em>指定</em><em>IP</em>可<em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-14</span>
				<span class="read-num hover-hide">
					阅读数 
					36</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33907511/article/details/91104429" target="_blank" title="MySql授权指定IP可访问">
				<span class="desc oneline">测试是否允许远程连接$telnet123.1.1.13306host123.1.1.1isnotallowedtoconnecttothismysqlserver【输出这个证明当前主机是无法访问到12...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33907511">来自：	<span class="blog_title"> weixin_33907511的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/weixin_33912453/article/details/87502865","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_33912453/article/details/87502865" target="_blank" title="Mysql 允许所有IP访问">
		<h4 class="text-truncate oneline">
				<em>Mysql</em> 允许所有<em>IP</em><em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-06</span>
				<span class="read-num hover-hide">
					阅读数 
					392</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_33912453/article/details/87502865" target="_blank" title="Mysql 允许所有IP访问">
				<span class="desc oneline">随手记$mysql-uroot-pEnterpassword:mysql&amp;amp;gt;usemysql#mysql&amp;amp;gt;GRANTALLON*.*toroot@'192.168.1.4'I...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_33912453">来自：	<span class="blog_title"> weixin_33912453的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/tuiyidelongdidi/article/details/84549783","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/tuiyidelongdidi/article/details/84549783" target="_blank" title="mysql授权其他IP访问">
		<h4 class="text-truncate oneline">
				<em>mysql</em><em>授权</em>其他<em>IP</em><em>访问</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-16</span>
				<span class="read-num hover-hide">
					阅读数 
					31</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/tuiyidelongdidi/article/details/84549783" target="_blank" title="mysql授权其他IP访问">
				<span class="desc oneline">注：必须使用root用户 dbname：数据库名称root：用户名  passwd：密码 grant all privileges on dbname.* to root@'localhost' id...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/tuiyidelongdidi">来自：	<span class="blog_title"> tydldd</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/qq_40180411/article/details/81253141","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_40180411/article/details/81253141" target="_blank" title="远程连接MySQL数据库与数据库授权">
		<h4 class="text-truncate oneline">
				远程连接<em>MySQL</em>数据库与数据库<em>授权</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-27</span>
				<span class="read-num hover-hide">
					阅读数 
					1781</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_40180411/article/details/81253141" target="_blank" title="远程连接MySQL数据库与数据库授权">
				<span class="desc oneline">我们在刚学习MySQL数据库时一般都是连接localhost然后登录root用户创建数据库进行操作，那么问题来了，如何通过其他主机来访问自己的数据库呢？一、我们要保证两台主机在同一个局域网，也就是说你...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_40180411">来自：	<span class="blog_title"> qq_40180411的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix"  data-report-click='{"mod":"popu_387","dest":"https://blog.csdn.net/hellokandy/article/details/82666529","strategy":"BlogCommendFromQuerySearch","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hellokandy/article/details/82666529" target="_blank" title="MySQL 允许局域网内其他网段主机访问本地MySql数据库">
		<h4 class="text-truncate oneline">
				<em>MySQL</em> 允许局域网内其他网段主机<em>访问</em>本地<em>MySql</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-12</span>
				<span class="read-num hover-hide">
					阅读数 
					1613</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hellokandy/article/details/82666529" target="_blank" title="MySQL 允许局域网内其他网段主机访问本地MySql数据库">
				<span class="desc oneline">一般来讲，局域网内无法访问远程MySQL数据库有两个原因：1、MySQL的账号权限问题，这个只要授权即可。2、远程MySQL数据库所在电脑的防火墙设置问题。 【授权】针对第一个问题的解决方案如下，也可...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hellokandy">来自：	<span class="blog_title"> hellokandy的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtTaYg4sNDItZWR1.html" target="_blank">
                        内网访问web服务器教程</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtTaAg3sNjMtZWR1.html" target="_blank">
                        区块链的服务器</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/hyy_217">
              <img src="https://avatar.csdn.net/A/5/4/3_hyy_217.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/8.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/hyy_217"  class="" id="uid">hyy_217</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="30">
                        <dt><a href="https://blog.csdn.net/hyy_217?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/hyy_217?t=1"><span class="count">30</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="2">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">2</span></dd>
        </dl>
        <dl class="text-center" title="1">
            <dt>喜欢</dt>
            <dd><span class="count">1</span></dd>
        </dl>
        <dl class="text-center" title="1">
            <dt>评论</dt>
            <dd><span class="count">1</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="4级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-4"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="84865">
                8万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="1018">
                1018            </dd>
        </dl>
        <dl title="73393">
            <dt>排名：</dt>
            <dd>7万+</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="持之以恒">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/chizhiyiheng.svg" alt="">
                                   <p>持之以恒</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然月内发布4篇或4篇以上原创或翻译IT博文的用户。不积跬步无以至千里，不积小流无以成江海，程序人生的精彩需要坚持不懈地积累！                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/hyy_217">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-76","con":",,"}' data-track-click='{"mod":"kp_popu_56-76","con":",,"}' data-report-view='{"mod":"kp_popu_56-76","keyword":""}' data-report-click='{"mod":"kp_popu_56-76","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3032528",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/hyy_217/article/details/73188438" target="_blank" >
                                        通过mysql的information_schema库来进行全库搜索字段所在表                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/hyy_217/article/details/73182092" target="_blank" >
                                        mysql 磁盘读写的I/O优化                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/hyy_217/article/details/73181428" target="_blank" >
                                        mysql的慢日志                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/hyy_217/article/details/73162829" target="_blank" >
                                        postgresql 日志中报xlog目录中文件找不到                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/hyy_217/article/details/73162681" target="_blank" >
                                        MYISAM表损坏 通过mysqlcheck进行表修复                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6908865">
                    <span class="title oneline">PostgreSql</span>
                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6908902">
                    <span class="title oneline">Mysql</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6908905">
                    <span class="title oneline">Windows</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6909090">
                    <span class="title oneline">SVN</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6909093">
                    <span class="title oneline">LINUX</span>
                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6909793">
                    <span class="title oneline">DB2</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6909844">
                    <span class="title oneline">ORACLE</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6909863">
                    <span class="title oneline">打包工具</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6915279">
                    <span class="title oneline">BAT</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6938422">
                    <span class="title oneline">vmware</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/hyy_217/article/category/6942817">
                    <span class="title oneline">JDBC</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/hyy_217/article/month/2017/06">
                    2017年6月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/hyy_217/article/month/2017/05">
                    2017年5月                    <span class="count float-right">37篇</span>
                </a>
            </li>
                    </ul>
    </div>
    </div>
<div id="asideHotArticle" class="aside-box">
	<h3 class="aside-title">热门文章</h3>
	<div class="aside-content">
		<ul class="hotArticle-list csdn-tracking-statistics tracking-click" data-report-view='{"mod":"popu_521"}'>
							<li>

					<a href="https://blog.csdn.net/hyy_217/article/details/72779642" >
                                                如何在Windows上开启Ping或者禁止PING                    </a>
					<p class="read">阅读数 <span>24613</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/hyy_217/article/details/72781614" >
                                                mysql5.7日志时间与系统时间不一致                    </a>
					<p class="read">阅读数 <span>8914</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/hyy_217/article/details/72726662" >
                                                设置VMware随系统开机自动启动并引导虚拟机操作系统启动                    </a>
					<p class="read">阅读数 <span>8142</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/hyy_217/article/details/71743214" >
                                                INNO setup打包的一段界面美化的code端代码                    </a>
					<p class="read">阅读数 <span>5667</span></p>
				</li>
							<li>

					<a href="https://blog.csdn.net/hyy_217/article/details/71473333" >
                                                postgresql创建只读用户                    </a>
					<p class="read">阅读数 <span>5290</span></p>
				</li>
					</ul>
	</div>
</div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/hyy_217/article/details/71512461#comments">DB2的备份(backup)和恢复...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/LemonTreey" class="user-name" target="_blank">LemonTreey：</a>你们写这个都自己试过了嘛？网上一查全他妈一样的，不知道8.2版本以后就无效了？https://www.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.db2.luw.messages.sql.doc/doc/msql01597n.html。看你们写的东西真的是脑壳疼。                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-77","con":",,"}' data-track-click='{"mod":"kp_popu_57-77","con":",,"}' data-report-view='{"mod":"kp_popu_57-77","keyword":""}' data-report-click='{"mod":"kp_popu_57-77","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3163270",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/hyy_217/article/details/72771306" title="centos7.x 安装mysql5.6">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/hyy_217/article/details/72779642" title="如何在Windows上开启Ping或者禁止PING">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/hyy_217/article/details/72771306" title="centos7.x 安装mysql5.6">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/hyy_217/article/details/72779642" title="如何在Windows上开启Ping或者禁止PING">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "72771802";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/hyy_217/article/details/72771802";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "授权指定ip访问mysql 服务器 - Hua的博客";
    var needInsertBaidu = false;
    // 代码段样式
    var codeStyle = '';
	var highlight = ["\u6388\u6743","\u6307\u5b9a","ip","\u8bbf\u95ee","mysql","\u670d\u52a1\u5668"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

<!-- 高亮未与 markdown兼容  -->
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/chart.css" />
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/lib/chart.min.js"></script>
	<script type="text/javascript" src="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/chart/widget2chart.js"></script>
	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin3-template/skin3-template-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js?t=20190307095522"></script>


<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
